create external table if not exists jms_ods.tab_report_shift_operate_hi(
   id                       string       comment'主键'
  ,transport_center_code    string       comment'转运中心编码'
  ,transport_center_name    string       comment'转运中心名称'
  ,shift_start_time         timestamp    comment'操作班次开始时间'
  ,shift_end_time           timestamp    comment'操作班次结束时间'
  ,effect_start_time        timestamp    comment'生效时间'
  ,effect_end_time          timestamp    comment'失效时间'
  ,modify_by                string       comment'维护人'
  ,modify_time              timestamp    comment'维护时间'
) comment '转运中心班次维护表'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_ods.db/external/tab_report_shift_operate_hi'
tblproperties (
'parquet.column.index.access' = 'true'
);
